{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["tytuł","założenia","wskaźniki emisji","wyniki","monitoring","analizy sektor publiczny","analizy sektor prywatny","budynki uzytecznosci publicznej","energia elektryczna","gospodarstwa domowe","Transport","Tranzyt"," prognoza na rok 2020 z perspek"],"not_rendered":{"charts":4,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"tytuł","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,1,4,6]]}
[]
[]
[]
[]
[null,"Inwentaryzacja emisji gazów cieplarnianych w Mieście Stoczek Łukowski"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"W niniejszym opracowaniu skorzystano ze wskaźników emisji oraz wartości opałowych paliw zawartych w materiałach opublikowanych przez Krajowy Ośrodek Bilansowania"]
[null,"i Zarządzania Emisjami"]
[]
[null,"Rok bazowy",2007]

{"sheet":"założenia","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Założenia do opracowania wyników inwentaryzacji"]
[]
[]
["Lp.","Nazwa",2007,"j.m.","źródło danych"]
[null,"Ludność"]
[1,"Liczba mieszkańców Gminy",2709,"osoba","BDL"]
[2,"Liczba mieszkańców Powiatu","107 997","osoba","BDL"]
[]
[null,"Energia Elektryczna"]
[null,"Ilość energii elektrycznej zużytej przez odbiorców z obszaru gminy Janów Podlaski"]
[3,"Całkowite zużycie energii elektrycznej",{"$f":"'energia elektryczna'!D11/1000","v":2455.7179999999998},"(MWh/rok)","PGE Dystrybucja S.A. Oddział Lublin"]
[4,"Zużycie energii elektrycznej na mieszkańca",730,"(KWh/rok)","PGE Dystrybucja S.A. Oddział Lublin"]
[5,"Zużycie energii elektrycznej na odbiorcę",null,"(KWh/rok)","PGE Dystrybucja S.A. Oddział Lublin"]
[null,"gospodarstwa domowe"]
[6,"Liczba gospodarstw domowych w Gminie",948,"sztuka","BDL"]
[7,"Liczba gospodarstw domowych w Powiecie",40909,"sztuka","BDL"]
[8,"Powierzchnia użytkowa mieszkań",63576,"m2","BDL"]
[9,"Przeciętna powierzchnia użytkowa   1 mieszkania w m²: ",67,"m2","BDL"]
[null,"                                       "]
[null,"Struktura ogrzewania: udział poszczególnych źródeł energii"]
[10,"Węgiel kamienny",960,"tony","BDL"]
[11,"Energia elektryczna",null,"MWh","BDL"]
[12,"Gaz ziemny",343314,"m3","BDL"]
[13,"Drewno",572.29999999999995,"m3","UG"]
[14,"Olej opałowy",108,"tony","UG"]
[15,"Zapotrzebowanie na energię cieplną",200,"kWh/m2 /rok"]
[null,"Wartość opałowa:"]
[16,"Węgiel kamienny",24,"GJ/t"]
[17,"Gaz ziemny",3.9959040000000001E-2,"GJ/m3",null,"Pellet ze słomy",16,"GJ/t"]
[18,"Drewno",7.64,"GJ/m3"]
[19,"Olej opałowy",43,"GJ/t"]
[null,"Transport"]
[null,"Liczba pojazdów poruszających się po terenie Miasta"]
[20,"samochody osobowe",700,"sztuka","BDL"]
[21,"motocykle   ",150,"sztuka","BDL"]
[22,"samochody dostawcze   ",120,"sztuka","BDL"]
[23,"samochody ciężarowe  ",20,"sztuka","BDL"]
[24,"samochody ciężarowe 'z przyczepą   ",12,"sztuka","BDL"]
[25,"ciągniki ",50,"sztuka","BDL"]
[26,"autobusy ",4,"sztuka","BDL"]
[null,"Oświetlenie Publiczne"]
[27,"Urząd Gminy"]
[28,"Liczba lamp",267,"szt.","UG"]
[29,"Zużycie energii elektrycznej",101018,"kWh","UG"]

{"sheet":"wskaźniki emisji","index":2,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Wskaźniki emisji przyjęte do wyliczeń"]
[]
[]
[null,"Źródło: Wartości opałowe (WO) i wskaźniki emisji CO2 (WE) w roku 2011 do raportowania w ramach Wspólnotowego Systemu Handlu Uprawnieniami do Emisji za rok 2014"]
[]
["lp.","Rodzaj paliwa","standardowe wskaźniki emisji "]
[1,"drewno",0.109,"MgCO2/GJ"]
[2,"gaz ziemny",5.5E-2,"MgCO2/GJ."]
[3,"olej opałowy",7.5999999999999998E-2,"MgCO2/GJ"]
[4,"węgiel kamienny",9.8000000000000004E-2,"MgCO2/GJ"]
[5,"energia elektryczna",0.89,"Mg/MWh"]
[]
[null,"założenia"]
[null,"1 GJ",0.27777777777787999]
[null,"1 MWh",{"$f":"3.6","v":3.6}]
[]
["Wartości opałowe i ekwiwalent CO2"]
[]
["lp.","rodzaj paliwa","wartość opałowa","źródło danych","GJ/Mg","MWh","tCO2",null,"1 l","1 Mg","1 m3",null,null,"1 MWh"]
[1,"benzyna",44.3,"IPCC 2006",{"$f":"C20","v":44.3},{"$f":"E20*$C$14","v":12.305555555560083},{"$f":"F20*#REF!","v":{"$error":"#REF!"}},null,"0,755 kg",{"$f":"0.755*0.001","v":7.5500000000000003E-4},null,null,null,{"$f":"E20*J20*$C$14","v":9.2906944444478626E-3}]
[2,"ciepło sieciowe",94.5,null,{"$f":"C21","v":94.5},{"$f":"94.5/C14/1000","v":0.34019999999987482},{"$f":"F21","v":0.34019999999987482}]
[3,"drewno",9500,"KCIE, 2003","-",{"$f":"C22/1000*$C$14","v":2.6388888888898601},{"$f":"F22*C7","v":0.28763888888899475}]
[4,"gaz ziemny",48,"IPCC 2006",{"$f":"C23","v":48},{"$f":"E23*$C$14","v":13.333333333338238},{"$f":"F23*C8","v":0.73333333333360307},null,null,{"$f":"0.716/1000","v":7.1599999999999995E-4},null,"0,716 kg/m3","PGNIG",{"$f":"E23*J23*$C$14","v":9.5466666666701779E-3}]
[5,"koks",7.8,"IPCC 2006",7.8,2.1666666666674637,{"$f":"F24*#REF!","v":{"$error":"#REF!"}}]
[6,"LPG",47.3,"IPCC 2006",47.3,13.138888888893723,{"$f":"F25*#REF!","v":{"$error":"#REF!"}},null,"0,5 kg",{"$f":"0.5*0.001","v":5.0000000000000001E-4},null,null,null,{"$f":"E25*J25*$C$14","v":6.5694444444468611E-3}]
[7,"odpady komunalne",10,"IPCC 2006",10,2.7777777777788,{"$f":"F26*#REF!","v":{"$error":"#REF!"}}]
[8,"olej napędowy",43,"IPCC 2006",43,11.944444444448839,{"$f":"F27*#REF!","v":{"$error":"#REF!"}},null,"0,84 kg",{"$f":"0.84*0.001","v":8.4000000000000003E-4},null,null,null,{"$f":"E27*J27*$C$14","v":1.0033333333337025E-2}]
[9,"olej opałowy",40.4,"IPCC 2006",40.4,11.222222222226351,{"$f":"F28*C9","v":0.85288888888920267},null,"0,85 kg",{"$f":"0.85*0.001","v":8.4999999999999995E-4},null,null,null,{"$f":"E28*J28*$C$14","v":9.5388888888923978E-3}]
[10,"węgiel brunatny",11.9,"IPCC 2006",11.9,3.3055555555567717,{"$f":"F29*#REF!","v":{"$error":"#REF!"}}]
[11,"węgiel kamienny",26.7,"IPCC 2006",26.7,7.4166666666693954,{"$f":"F30*C10","v":0.72683333333360078}]
[12,"energia elektryczna",null,"IPCC 2006",null,1,{"$f":"F31*C11","v":0.89}]
[13,"biomasa",null,"KCIE, 2003",null,{"$f":"F22","v":2.6388888888898601},{"$f":"F32*C12","v":0}]
[null,"Średnie jednostkowe emisje CO2 dla poszczególnych kategorii pojazdów:"]
[1,"samochody osobowe ",155,"g/km"]
[2,"samochody dostawcze ",200,"g/km"]
[3,"samochody ciężarowe jednoczłonowe 450 g/km",450,"g/km"]
[4,"samochody ciężarowe z naczepą/przyczepą ",900,"g/km"]
[5,"autobusy ",450,"g/km"]
[6,"motocykle",150,"g/km"]

{"sheet":"wyniki","index":3,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[33,2,33,17],[34,2,34,17],[35,2,35,17],[6,1,8,1],[6,0,8,0],[20,0,22,0],[20,1,22,1],[20,2,20,17],[21,4,21,11],[21,12,21,15],[21,17,22,17],[7,12,7,15],[7,17,8,17],[6,2,6,17],[7,4,7,11],[32,2,32,17]]}
[null,"rok bazowy",{"$f":"tytuł!C25","v":0}]
[]
[]
[]
[]
[null,"Tabela: Finalne zużycie energii w roku bazowym w gminie [GJ] "]
["lp.","Kategoria","końcowe zużycie energii [GJ]"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OZE",null,null,null,null,"Razem"]
[null,null,"energia elektryczna","ciepło / chłód","gaz ziemny","gaz ziemny","olej opałowy","koks opałowy","drewno","węgiel brunatny","węgiel kamienny","inne paliwa kopalne","olej roślinny","inna biomasa","słoneczna, cieplna","geotermiczna","LPG"]
["I","Gminne jednostki organizacyjne"]
[1,"Ogrzewanie budynków administracji publicznej",0,{"$f":"INT('budynki uzytecznosci publicznej'!I18*'wskaźniki emisji'!C14+#REF!*'wskaźniki emisji'!C14)","v":{"$error":"#REF!"}},{"$f":"INT('budynki uzytecznosci publicznej'!H18*'wskaźniki emisji'!N23+#REF!*'wskaźniki emisji'!N23)","v":{"$error":"#REF!"}},{"$f":"'budynki uzytecznosci publicznej'!I18","v":1022.951424},null,0,0,null,{"$f":"'budynki uzytecznosci publicznej'!J18","v":360},null,null,null,null,null,0,{"$f":"SUM(Q11,K11,I11,H11,G11,F11,C11)","v":1382.9514239999999}]
[2,"Budynki administracji publicznej - energia elektryczna",{"$f":"'analizy sektor publiczny'!C6","v":1357.6679999995004},{"$f":"INT(#REF!*'wskaźniki emisji'!C14)","v":{"$error":"#REF!"}},{"$f":"INT(#REF!*'wskaźniki emisji'!N23)","v":{"$error":"#REF!"}},0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q12,K12,I12,H12,G12,F12,C12)","v":1357.6679999995004}]
[3,"Komunalne oświetlenie publiczne",{"$f":"'analizy sektor publiczny'!C7","v":363.6647999998662},0,0,0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q13,K13,I13,H13,G13,F13,C13)","v":363.6647999998662}]
[null,"Gospodarstwa domowe",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11:L13)","v":0},{"$f":"SUM(M11:M13)","v":0},{"$f":"SUM(N11:N13)","v":0},{"$f":"SUM(O11:O13)","v":0},{"$f":"SUM(P11:P13)","v":0}]
[4,"gospodarstwa domowe -  ogrzewanie",{"$f":"'analizy sektor prywatny'!C6","v":0},null,null,{"$f":"'analizy sektor prywatny'!F6","v":13718.49785856},{"$f":"'analizy sektor prywatny'!H7","v":4644},0,{"$f":"'analizy sektor prywatny'!I6","v":4372.3719999999994},null,{"$f":"'analizy sektor prywatny'!K6","v":23040},null,null,null,null,null,0,{"$f":"SUM(Q15,K15,I15,H15,G15,F15,C15,)","v":45774.86985856}]
[5,"gospodarstwa domowe - energia elektyczna",{"$f":"'energia elektryczna'!D9/1000/'wskaźniki emisji'!C14","v":7119.2519999973802},null,null,0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q16,K16,I16,H16,G16,F16,C16)","v":7119.2519999973802}]
[null,"Łącznie końcowe zużycie energii",{"$f":"C11+C12+C13+C15+C16","v":8840.5847999967464},{"$f":"#REF!+D14","v":{"$error":"#REF!"}},{"$f":"#REF!+E14","v":{"$error":"#REF!"}},{"$f":"SUM(F15:F16)","v":13718.49785856},{"$f":"SUM(G15:G16)","v":4644},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":4372.3719999999994},{"$f":"#REF!+J14","v":{"$error":"#REF!"}},{"$f":"SUM(K15:K16)","v":23040},{"$f":"#REF!+L14","v":{"$error":"#REF!"}},{"$f":"#REF!+M14","v":{"$error":"#REF!"}},{"$f":"#REF!+N14","v":{"$error":"#REF!"}},{"$f":"#REF!+O14","v":{"$error":"#REF!"}},{"$f":"#REF!+P14","v":{"$error":"#REF!"}},{"$f":"SUM(Q15:Q16)","v":0},{"$f":"R11+R12+R13+R15+R16","v":55998.40608255675}]
[]
[]
[null,"Tabela: Wyniki inwentaryzacji bazowej emisji dwutlenku węgla w gminie [Mg CO2]"]
["lp.","Kategoria","emisje CO2 [t]"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OZE",null,null,null,null,"Razem"]
[null,null,"energia elektryczna","ciepło / chłód","gaz ziemny","gaz ziemny","olej opałowy","koks opałowy","drewno","węgiel brunatny","węgiel kamienny","inne paliwa kopalne","olej roślinny","inna biomasa","słoneczna, cieplna","geotermiczna","LPG"]
["I","Gminne jednostki organizacyjne"]
[1,"Ogrzewanie budynków administracji publicznej",0,{"$f":"INT('budynki uzytecznosci publicznej'!I32*'wskaźniki emisji'!C28+#REF!*'wskaźniki emisji'!C28)","v":{"$error":"#REF!"}},{"$f":"INT('budynki uzytecznosci publicznej'!H32*'wskaźniki emisji'!N37+#REF!*'wskaźniki emisji'!N37)","v":{"$error":"#REF!"}},{"$f":"'budynki uzytecznosci publicznej'!P18","v":59.283231743999998},{"$f":"'budynki uzytecznosci publicznej'!N18","v":77.744308223999994},0,0,null,{"$f":"'budynki uzytecznosci publicznej'!L18","v":35.28},null,null,null,null,null,0,{"$f":"SUM(Q25,K25,I25,H25,G25,F25,C25)","v":172.30753996799999}]
[2,"Budynki administracji publicznej - energia elektryczna",{"$f":"'budynki uzytecznosci publicznej'!K18","v":335.64569999999998},{"$f":"INT(#REF!*'wskaźniki emisji'!C28)","v":{"$error":"#REF!"}},{"$f":"INT(#REF!*'wskaźniki emisji'!N37)","v":{"$error":"#REF!"}},0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q26,K26,I26,H26,G26,F26,C26)","v":335.64569999999998}]
[3,"Komunalne oświetlenie publiczne",{"$f":"'energia elektryczna'!G8","v":89.906019999999998},0,0,0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q27,K27,I27,H27,G27,F27,C27)","v":89.906019999999998}]
["II","Gospodarstwa domowe",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L27)","v":0},{"$f":"SUM(M25:M27)","v":0},{"$f":"SUM(N25:N27)","v":0},{"$f":"SUM(O25:O27)","v":0},{"$f":"SUM(P25:P27)","v":0}]
[1,"Gospodarstwa domowe -  ogrzewanie",{"$f":"'gospodarstwa domowe'!V9","v":0},null,null,{"$f":"'gospodarstwa domowe'!AA9","v":754.51738222079996},{"$f":"'gospodarstwa domowe'!Y9","v":352.94400000000002},0,{"$f":"'gospodarstwa domowe'!X9","v":476.58854799999995},null,{"$f":"'gospodarstwa domowe'!W9","v":2257.92},null,null,null,null,null,0,{"$f":"SUM(Q29,K29,I29,H29,G29,F29,C29,)","v":3841.9699302207996}]
[2,"Gospodarstwa domowe - energia elektyczna",{"$f":"'energia elektryczna'!G15","v":1760.0373},null,null,0,0,0,0,null,0,null,null,null,null,null,0,{"$f":"SUM(Q30,K30,I30,H30,G30,F30,C30)","v":1760.0373}]
[null,"Razem",{"$f":"SUM(C25:C30)","v":2185.5890199999999},null,null,{"$f":"SUM(F25:F30)","v":813.80061396479994},{"$f":"SUM(G25:G30)","v":430.68830822400002},{"$f":"SUM(H25:H30)","v":0},{"$f":"SUM(I25:I30)","v":476.58854799999995},null,{"$f":"SUM(K25:K30)","v":2293.2000000000003},null,null,null,null,null,{"$f":"SUM(Q29:Q35)","v":0},{"$f":"SUM(R25:R30)","v":6199.8664901887996}]
[]
[null,"Transport "]
[1,"Transport lokalny",{"$f":"Transport!H15","v":1604.8500000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R31+C36","v":7955.3825441888002}]
[2,"Tranzyt",{"$f":"SUM(Tranzyt!N15,Tranzyt!R15,Tranzyt!R36,Tranzyt!N36)","v":150.666054}]
[null,"Razem",{"$f":"SUM(C34:C35)","v":1755.5160540000002}]
[]
[]
[null,"Wykres: Struktura sektorowa inwentaryzacji bazowej emisji dwutlenku węgla [%]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabela pomocnicza","emisja CO2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategoria","Sektory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B25","v":"Ogrzewanie budynków administracji publicznej"},{"$f":"R25","v":172.30753996799999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B26","v":"Budynki administracji publicznej - energia elektryczna"},{"$f":"R26","v":335.64569999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B27","v":"Komunalne oświetlenie publiczne"},{"$f":"R27","v":89.906019999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B28","v":"Gospodarstwa domowe"},{"$f":"SUM(R29:R30)","v":5602.0072302207991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"transport",{"$f":"C36","v":1755.5160540000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Razem",{"$f":"SUM(U43:U49)","v":7955.3825441887984}]

{"sheet":"monitoring","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Tabela: Wartości wskaźników oceny dla roku bazowego"]
[]
["Lp.","Wskaźniki oceny","Jednostka",{"$f":"tytuł!C25","v":0}]
[1,"Poziom emisji dwutlenku węgla w gminie","Mg CO2/rok",{"$f":"wyniki!R31+wyniki!C36","v":7955.3825441888002}]
[2,"Wielkość emisji dwutlenku węgla w sektorze publicznym","Mg CO2/rok",{"$f":"SUM(wyniki!R25:R27)","v":597.85925996799995}]
[3,"Emisja dwutlenku węgla per capita","Mg CO2/os.",{"$f":"SUM(wyniki!R31,wyniki!C36)/założenia!C6","v":2.9366491488330748}]
[4,"Poziom zużycia energii końcowej w sektorze publicznym","MWh/rok",{"$f":"'analizy sektor publiczny'!L10*'wskaźniki emisji'!C14","v":862.30117333347471}]
[5,"Całkowite zużycie energii ","MWh/rok",{"$f":"SUM('analizy sektor publiczny'!L10,'analizy sektor prywatny'!O7)*'wskaźniki emisji'!C14","v":13577.542800715932}]
[6,"Zużycie energii końcowej per capita","MWh/os.",{"$f":"D10/założenia!C6","v":5.0120128463329392}]

{"sheet":"analizy sektor publiczny","index":5,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[12,1,12,10],[24,1,24,10]]}
["Analizy i wskaźniki - sektor publiczny"]
[]
[]
[null,"Tabela: Finalne zużycie energii w sektorze publicznym w roku bazowym [GJ] "]
["lp.","Żródło emisji","energia elektryczna","olej opałowy","gaz ciekły","gaz ziemny","benzyna","olej napędowy","węgiel brunatny","węgiel kamienny","OZE","razem"]
[1,"Obiekty użyteczności publicznej",{"$f":"'budynki uzytecznosci publicznej'!D18/1000/'wskaźniki emisji'!C14","v":1357.6679999995004},0,0,{"$f":"'budynki uzytecznosci publicznej'!I18","v":1022.951424},0,0,0,{"$f":"'budynki uzytecznosci publicznej'!J18","v":360},0,{"$f":"SUM(C6:K6)","v":2740.6194239995002}]
[3,"Komunalne oświetlenie publiczne",{"$f":"'energia elektryczna'!D8/1000/'wskaźniki emisji'!C14","v":363.6647999998662},0,0,0,0,0,0,0,0,{"$f":"SUM(C7:K7)","v":363.6647999998662}]
[4,"Tabor gminny","bd",0,0,0,0,0,0,0,0,{"$f":"SUM(C8:K8)","v":0}]
[5,"Transport publiczny","bd",0,0,0,0,0,0,0,0,{"$f":"SUM(C9:K9)","v":0}]
[null,"Łącznie zużycie energii",{"$f":"SUM(C6:C9)","v":1721.3327999993667},{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0},{"$f":"SUM(F6:F9)","v":1022.951424},0,0,{"$f":"SUM(I6:I9)","v":0},{"$f":"SUM(J6:J9)","v":360},{"$f":"SUM(K6:K9)","v":0},{"$f":"SUM(C10:K10)","v":3104.2842239993665}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L10+'analizy sektor prywatny'!O6","v":48879.154082559369}]
[null,"Wykres: Struktura udziału poszczególnych podsektorów w finalnym zużyciu energii sektora publicznego w roku bazowym [%]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabela pomocnicza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategoria","Publiczne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":"Obiekty użyteczności publicznej"},{"$f":"L6","v":2740.6194239995002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"Komunalne oświetlenie publiczne"},{"$f":"L7","v":363.6647999998662}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8","v":"Tabor gminny"},{"$f":"L8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B9","v":"Transport publiczny"},{"$f":"L9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Razem",{"$f":"SUM(S16:S19)","v":3104.2842239993665}]
[]
[]
[]
[]
[null,"Wykres: Struktura udziału poszczególnych nośników energii w finalnym zużyciu energii sektora publicznego w roku bazowym [%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabela pomocnicza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategoria","Paliwa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C5","v":"energia elektryczna"},{"$f":"C10","v":1721.3327999993667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D5","v":"olej opałowy"},{"$f":"D10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E5","v":"gaz ciekły"},{"$f":"E10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":"gaz ziemny"},{"$f":"F10","v":1022.951424}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G5","v":"benzyna"},{"$f":"G10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H5","v":"olej napędowy"},{"$f":"H10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I5","v":"węgiel brunatny"},{"$f":"I10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J5","v":"węgiel kamienny"},{"$f":"J10","v":360}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K5","v":"OZE"},{"$f":"K10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Razem",{"$f":"SUM(S27:S35)","v":3104.2842239993665}]

{"sheet":"analizy sektor prywatny","index":6,"n_rows":18,"n_cols":22,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,1,9,15]]}
["Analizy i wskaźniki - sektor prywatny"]
[]
[]
[null,"Tabela: Finalne zużycie energii w sektorze prywatnym w roku bazowym [GJ] "]
["lp.","Kategoria","energia elektryczna","ciepło / chłód","gaz ziemny","gaz ziemny","olej opałowy","olej opałowy","drewno","węgiel brunatny","węgiel kamienny","inne paliwa kopalne","OZE","LPG","razem"]
[1,"Gospodarstwa domowe",{"$f":"'gospodarstwa domowe'!H8/'wskaźniki emisji'!C14","v":0},{"$f":"INT(#REF!)*'wskaźniki emisji'!C14","v":{"$error":"#REF!"}},{"$f":"INT((#REF!*'wskaźniki emisji'!N23))","v":{"$error":"#REF!"}},{"$f":"'gospodarstwa domowe'!N8","v":13718.49785856},{"$f":"INT((#REF!)*'wskaźniki emisji'!N28)","v":{"$error":"#REF!"}},{"$f":"'gospodarstwa domowe'!L9","v":4644},{"$f":"'gospodarstwa domowe'!P8","v":4372.3719999999994},0,{"$f":"'gospodarstwa domowe'!S8","v":23040},0,0,0,{"$f":"SUM(C6,F6,H6,I6,K6)","v":45774.86985856}]
[null,"Łącznie zużycie energii",{"$f":"SUM(C6:C6)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},13718.49785856,{"$error":"#REF!"},4644,4372.3719999999994,0,23040,0,null,null,{"$f":"SUM(O6)","v":45774.86985856}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabela pomocnicza"]
[null,"Wykres: Struktura udziału poszczególnych nośników energii w finalnym zużyciu energii sektora prywatnego w roku bazowym [%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategoria","Paliwa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C5","v":"energia elektryczna"},{"$f":"C7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":"gaz ziemny"},{"$f":"F7","v":13718.49785856}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H5","v":"olej opałowy"},{"$f":"H7","v":4644}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I5","v":"drewno"},{"$f":"I7","v":4372.3719999999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J5","v":"węgiel brunatny"},{"$f":"J7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K5","v":"węgiel kamienny"},{"$f":"K7","v":23040}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OZE",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V11:V17)","v":45774.86985856}]

{"sheet":"budynki uzytecznosci publicznej","index":7,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,2,6,2],[5,0,6,0],[5,10,5,17]]}
[null,"budynki uzytecznosci publicznej"]
[]
[]
[null,"rok bazowy ",2007]
[]
["lp.","Dane podstawowe / Źródła energii","Źródło ciepła","energia elektryczna","węgiel kamienny","koks opałowy","olej opałowy","gaz ziemny","gaz- ilość wyprodukowanej energii (GJ)","węgiel- ilość wyprodukowanej energii (GJ)","Obliczenie wielkości emisji CO2"]
[null,"Nazwa",null,"roczne zużycie [kWh]","roczne zużycie [Mg]","roczne zużycie [Mg]","roczne zużycie [t]","roczne zużycie [m3]","roczne zużycie [GJ]","roczne zużycie [GJ]","energia elektryczna","węgiel kamienny","koks opałowy","olej opałowy","LPG (gaz płynny)","gaz ziemny","sieć cieplna","razem"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"D8/1000*'wskaźniki emisji'!C11","v":0},{"$f":"E8*'wskaźniki emisji'!$G$30","v":0},0,{"$f":"I8*'wskaźniki emisji'!C9","v":0},0,0,null,{"$f":"SUM(K8:Q8)","v":0}]
[1,"Zespół Oświatowy","gaz",292000,null,null,null,18000,{"$f":"H9*założenia!C29","v":719.26272000000006},null,{"$f":"D9/1000*'wskaźniki emisji'!C11","v":259.88},{"$f":"J9*'wskaźniki emisji'!C10","v":0},0,{"$f":"G9*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I9*'wskaźniki emisji'!C8","v":39.559449600000001},null,299.43944959999999]
[2," \tUrząd Miasta Stoczek Łukowski","węgiel",26000,8,null,null,null,null,{"$f":"E10*założenia!C28","v":192},{"$f":"D10/1000*'wskaźniki emisji'!$G$31","v":23.14},{"$f":"J10*'wskaźniki emisji'!C10","v":18.816000000000003},0,null,0,{"$f":"I10*'wskaźniki emisji'!C8","v":0},null,41.956000000000003]
[3,"  Miejski Ośrodek Kultury","gaz",21900,null,null,null,4000,{"$f":"H11*założenia!C29","v":159.83616000000001},null,{"$f":"D11/1000*'wskaźniki emisji'!C11","v":19.491},{"$f":"J11*'wskaźniki emisji'!$G$30","v":0},0,null,0,{"$f":"I11*'wskaźniki emisji'!C8","v":8.7909888000000009}]
[4,"      Miejski Ośrodek Pomocy Społecznej","węgiel",7300,2,null,null,null,null,{"$f":"E12*założenia!C28","v":48},{"$f":"D12/1000*'wskaźniki emisji'!$G$31","v":6.4969999999999999},{"$f":"J12*'wskaźniki emisji'!C10","v":4.7040000000000006},0,{"$f":"G12*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I12*'wskaźniki emisji'!C8","v":0},null,11.201000000000001]
[5,"Miejski Zakład Gospodarki Komunalnej","węgiel",8030,5,null,null,null,null,{"$f":"E13*założenia!C28","v":120},{"$f":"D13/1000*'wskaźniki emisji'!$G$31","v":7.1466999999999992},{"$f":"E13*'wskaźniki emisji'!$G$30","v":3.6341666666680039},0,{"$f":"G13*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I13*'wskaźniki emisji'!C8","v":0},null,10.780866666668004]
[6,"      Warsztat Terapii Zajęciowej","gaz",21900,null,null,null,3600,{"$f":"H14*założenia!C29","v":143.85254399999999},null,{"$f":"D14/1000*'wskaźniki emisji'!$G$31","v":19.491},{"$f":"E14*'wskaźniki emisji'!$G$30","v":0},0,{"$f":"G14*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I14*'wskaźniki emisji'!C9","v":10.932793343999998},null,30.423793343999996]
[8,null,null,null,null,null,null,null,null,null,{"$f":"D15/1000*'wskaźniki emisji'!$G$31","v":0},{"$f":"E15*'wskaźniki emisji'!$G$30","v":0},0,{"$f":"G15*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I15*'wskaźniki emisji'!C8","v":0},null,0]
[9,null,null,null,null,null,null,null,null,null,{"$f":"D16/1000*'wskaźniki emisji'!$G$31","v":0},{"$f":"E16*'wskaźniki emisji'!$G$30","v":0},0,{"$f":"G16*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I16*'wskaźniki emisji'!C8","v":0},null,0]
[10,null,null,null,null,null,null,null,null,null,{"$f":"D17/1000*'wskaźniki emisji'!$G$31","v":0},{"$f":"E17*'wskaźniki emisji'!$G$30","v":0},0,{"$f":"G17*'wskaźniki emisji'!$J$28*'wskaźniki emisji'!$G$28","v":0},0,{"$f":"I17*'wskaźniki emisji'!C8","v":0},null,0]
[null,"razem",null,{"$f":"SUM(D8:D17)","v":377130},15,0,0,25600,1022.951424,{"$f":"SUM(J8:J17)","v":360},{"$f":"D18/1000*'wskaźniki emisji'!$G$31","v":335.64569999999998},{"$f":"J18*'wskaźniki emisji'!C10","v":35.28},0,{"$f":"I18*'wskaźniki emisji'!C9","v":77.744308223999994},0,{"$f":"SUM(P8:P17)","v":59.283231743999998},null,{"$f":"SUM(K18:P18)","v":507.95323996799999}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(K18:Q18)","v":507.95323996799999},"(sumaryczna ilość dla wszystkich budynków)"]

{"sheet":"energia elektryczna","index":8,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,6,12,8],[5,4,6,4],[5,0,6,0],[5,2,6,2],[5,6,5,8]]}
[null,"Energia elektryczna"]
[]
[]
[null,"rok bazowy ",2007,2007]
[]
["lp.","Dane podstawowe / Zużycie energii","Liczba lamp [szt.]","energia elektryczna","Uwagi",null,"Obliczenia pomocnicze oswietlenie uliczne"]
[null,"Nazwa jednostki",null,"roczne zużycie [kWh]",null,null,"roczna emisja CO2","jednostkowe zużycie energii","emisja roczna CO2 w przeliczeniu na 1 lampę"]
[1,"Oświetlenie uliczne",975,101018,null,null,{"$f":"D8*'wskaźniki emisji'!C11/1000","v":89.906019999999998},{"$f":"IFERROR(D8/C8,\"-\")","v":103.60820512820513},{"$f":"IFERROR(G8/C8,\"-\")","v":9.2211302564102565E-2}]
[2,"Energia elektryczna-gospodarstwa domowe",0,{"$f":"założenia!C6*założenia!C12","v":1977570}]
[3,"Energia elektryczna gminne jednostki organizacyjne",0,{"$f":"'budynki uzytecznosci publicznej'!D18","v":377130}]
[null,"razem",null,{"$f":"SUM(D8:D10)","v":2455718}]
[]
[null,null,null,null,null,null,"Obliczenia pomocnicze energia elektryczna"]
[null,null,null,null,null,null,"roczna emisja CO2 -pozostali gospodarstwa domowe","emisja roczna CO2  - gminne jednostki organizacyjne","razem emisja z energii elektrycznej"]
[null,null,null,null,null,null,{"$f":"D9/1000*'wskaźniki emisji'!C11","v":1760.0373},{"$f":"D10/1000*'wskaźniki emisji'!C11","v":335.64569999999998},{"$f":"SUM(G8,G15,H15)","v":2185.5890199999999}]

{"sheet":"gospodarstwa domowe","index":9,"n_rows":12,"n_cols":29,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,21,5,28],[5,19,6,19],[5,0,6,0],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,8,5,9],[5,12,5,13],[5,14,5,15],[5,17,5,18],[5,10,5,11]]}
[null,"Mieszkalnictwo zapotrzebowanie na energię cieplną"]
[]
[]
[null,"rok bazowy ",{"$f":"wyniki!C1","v":0},null,null,{"$f":"tytuł!C25","v":0},2007,null,{"$f":"tytuł!C25","v":0}]
[]
["lp.","Dane podstawowe / Źródła energii","Powierzchnia budynków [m2]","Źródło ciepła","Liczba mieszkańców","Liczba gospodarstw domowych","Powierzchnia w m2","energia elektryczna","Zapotrzebowanie na energię cieplną",null,"olej opałowy",null,"gaz ziemny",null,"drewno",null,"OZE","węgiel kamienny",null,"Uwagi",null,"Obliczenie wielkości emisji CO2"]
[null,"Nazwa jednostki",null,null,null,null,null,"zapotrzebowanie [MWh]","roczne zużycie [kWh]","zapotrzebowanie [GJ]","roczne zużycie [t]","ilość wyprodukowanej energii [GJ]","roczne zużycie [m3]","ilość wyprodukowanej energii [GJ]","roczne zużycie [m3]","ilość wyprodukowanej energii [GJ]","roczne zużycie [m3]","roczne zużycie [t]","ilość wyprodukowanej energii[GJ]",null,null,"energia elektryczna","węgiel kamienny","drewno","olej opałowy","LPG (gaz płynny)","gaz ziemny","OZE","razem"]
[1,"Zasoby mieszkaniowe na terenie Gminy",{"$f":"założenia!C17","v":63576},null,{"$f":"założenia!C6","v":2709},{"$f":"założenia!C15","v":948},{"$f":"założenia!C17","v":63576},{"$f":"założenia!C22","v":0},{"$f":"G8*założenia!C26","v":12715200},{"$f":"I8/'wskaźniki emisji'!C14/1000","v":45774.719999983157},{"$f":"założenia!C25","v":108},{"$f":"założenia!C25*założenia!C31","v":4644},{"$f":"założenia!C23","v":343314},{"$f":"M8*założenia!C29","v":13718.49785856},{"$f":"założenia!C24","v":572.29999999999995},{"$f":"O8*założenia!C30","v":4372.3719999999994},0,{"$f":"założenia!C21","v":960},{"$f":"R8*założenia!C28","v":23040},null,null,{"$f":"H9*'wskaźniki emisji'!C11","v":0},{"$f":"S9*'wskaźniki emisji'!C10","v":2257.92},{"$f":"P9*'wskaźniki emisji'!C7","v":476.58854799999995},{"$f":"L9*'wskaźniki emisji'!C9","v":352.94400000000002},0,{"$f":"N8*'wskaźniki emisji'!C8","v":754.51738222079996},0,{"$f":"SUM(V8:AB8)","v":3841.9699302207996}]
[null,"razem",null,null,null,null,null,{"$f":"SUM(H8:H8)","v":0},{"$f":"SUM(I8:I8)","v":12715200},{"$f":"SUM(J8:J8)","v":45774.719999983157},0,{"$f":"SUM(L8:L8)","v":4644},343314,13718.49785856,572.29999999999995,4372.3719999999994,0,960,23040,null,null,{"$f":"SUM(V8:V8)","v":0},{"$f":"SUM(W8:W8)","v":2257.92},{"$f":"SUM(X8:X8)","v":476.58854799999995},{"$f":"SUM(Y8:Y8)","v":352.94400000000002},0,{"$f":"SUM(AA8:AA8)","v":754.51738222079996},{"$f":"SUM(AB8:AB8)","v":0},{"$f":"SUM(AC8:AC8)","v":3841.9699302207996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OZE:",{"$f":"Q9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"drewno [m3]",{"$f":"SUM(O9,Q9)","v":572.29999999999995}]

{"sheet":"Transport","index":10,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,4,6,4],[5,0,6,0],[5,2,6,2],[5,6,5,8],[5,3,6,3]]}
[null,"Transport lokalny"]
[]
[]
[null,"rok bazowy ",2007]
[]
["lp.",null,"Liczba pojazdów [szt.]","średni roczny przebieg [km]","Uwagi",null,"Obliczenie wielkości emisji CO2 transport lokalny [Mg]"]
[null,"Rodzaj pojazdów",null,null,null,null,"rodzaje pojazdów","emisja"]
[1,"samochody osobowe",{"$f":"założenia!C34","v":700},10500,null,null,"samochody osobowe",{"$f":"C8*D8*'wskaźniki emisji'!C34/1000000","v":1139.25}]
[2,"motocykle   ",{"$f":"założenia!C35","v":150},4000,null,null,"motocykle   ",{"$f":"C9*D9*'wskaźniki emisji'!C39/1000000","v":90}]
[3,"samochody dostawcze   ",{"$f":"założenia!C36","v":120},8000,null,null,"samochody dostawcze   ",{"$f":"C10*D10*'wskaźniki emisji'!C35/1000000","v":192}]
[4,"samochody ciężarowe  ",{"$f":"założenia!C37","v":20},6000,null,null,"samochody ciężarowe  ",{"$f":"C11*D11*'wskaźniki emisji'!C36/1000000","v":54}]
[5,"samochody ciężarowe z przyczepą   ",{"$f":"założenia!C38","v":12},6500,null,null,"samochody ciężarowe z przyczepą   ",{"$f":"C12*D12*'wskaźniki emisji'!C37/1000000","v":70.2}]
[6,"ciągniki ",{"$f":"założenia!C39","v":50},2000,null,null,"ciągniki ",{"$f":"C13*D13*'wskaźniki emisji'!C36/1000000","v":45}]
[8,"autobusy ",{"$f":"założenia!C40","v":4},8000,null,null,"autobusy ",{"$f":"C14*D14*'wskaźniki emisji'!C38/1000000","v":14.4}]
[9,null,null,null,null,null,"razem",{"$f":"SUM(H8:H14)","v":1604.8500000000001}]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[null,"razem",{"$f":"SUM(C8:C14)","v":1056}]

{"sheet":"Tranzyt","index":11,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,12,26,14],[26,16,26,18],[5,16,5,18],[5,0,6,0],[5,2,6,2],[5,3,6,3],[5,10,6,10],[5,12,5,14],[5,6,6,6],[5,7,6,7]]}
[null,"Tranzyt droga krajowa nr 12 i 17 i droga wojewódzka nr 835"]
[]
[null,"Źródło: opracowanie własne na podstawie danych Starostwa Powiatowego w Lublinie, Wydział Infrastruktury Drogowej,Pomiar ruchu na drogach wojewódzkich i krajowych GDDKiA 2010r."]
[null,"rok bazowy ",{"$f":"założenia!C4","v":2007}]
[]
["lp.",null,"tranzyt nadrodze wojewódziej nr 803 [szt./doba]","długość drogi nr 698  [km]",null,null,null,null,null,null,"Uwagi",null,"Obliczenie wielkości emisji CO2 tranzyt [Mg] -droga nr 803"]
[null,"Rodzaj pojazdów",null,null,null,null,null,null,null,null,null,null,"rodzaje pojazdów","emisja"]
[1,"samochody osobowe",14,1.21,null,null,null,null,null,null,null,null,"samochody osobowe",{"$f":"C8*D8*'wskaźniki emisji'!C34*365/1000000","v":0.95838049999999986}]
[2,"motocykle   ",1363,1.21,null,null,null,null,null,null,null,null,"motocykle   ",{"$f":"C9*D9*'wskaźniki emisji'!C39*365/1000000","v":90.295342500000004}]
[3,"samochody dostawcze   ",214,1.21,null,null,null,null,null,null,null,null,"samochody dostawcze   ",{"$f":"C10*D10*'wskaźniki emisji'!C35*365/1000000","v":18.902619999999999}]
[4,"samochody ciężarowe  ",65,1.21,null,null,null,null,null,null,null,null,"samochody ciężarowe  ",{"$f":"C11*D11*'wskaźniki emisji'!C36*365/1000000","v":12.918262499999997}]
[5,"samochody ciężarowe z przyczepą   ",44,1.21,null,null,null,null,null,null,null,null,"samochody ciężarowe z przyczepą   ",{"$f":"C12*D12*'wskaźniki emisji'!C37*356/1000000","v":17.058095999999995}]
[7,"ciągniki ",7,1.21,null,null,null,null,null,null,null,null,"ciągniki ",{"$f":"C13*D13*'wskaźniki emisji'!C36*365/1000000","v":1.3911974999999999}]
[8,"autobusy ",46,1.21,null,null,null,null,null,null,null,null,"autobusy ",{"$f":"C14*D14*'wskaźniki emisji'!C38*365/1000000","v":9.1421550000000007}]
[9,null,null,null,null,null,null,null,null,null,null,null,"razem",{"$f":"SUM(N8:N14)","v":150.666054}]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[null,"razem",{"$f":"SUM(C8:C14)","v":1753},null,{"$f":"SUM(E8:E14)","v":0},null,{"$f":"SUM(G8:G22)","v":0},null,{"$f":"SUM(I8:I22)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C23+E23+G23+I23","v":1753}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Obliczenie wielkości emisji CO2 tranzyt [Mg] -droga nr 830",null,null,null,"Obliczenie wielkości emisji CO2 tranzyt [Mg] -droga nr 860"]
[null,null,null,null,null,null,null,null,null,null,null,null,"rodzaje pojazdów","emisja",null,null,"rodzaje pojazdów","emisja"]
[null,null,null,null,null,null,null,null,null,null,null,null,"samochody osobowe",{"$f":"G8*H8*'wskaźniki emisji'!C34*356/1000000","v":0},null,null,"samochody osobowe",{"$f":"I8*J8*'wskaźniki emisji'!C34*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"motocykle   ",{"$f":"G9*H9*'wskaźniki emisji'!C35*356/1000000","v":0},null,null,"motocykle   ",{"$f":"I9*J9*'wskaźniki emisji'!C35*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"samochody dostawcze   ",{"$f":"G10*H10*'wskaźniki emisji'!C36*356/1000000","v":0},null,null,"samochody dostawcze   ",{"$f":"I10*J10*'wskaźniki emisji'!C36*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"samochody ciężarowe  ",{"$f":"G11*H11*'wskaźniki emisji'!C37*356/1000000","v":0},null,null,"samochody ciężarowe  ",{"$f":"I11*J11*'wskaźniki emisji'!C37*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"samochody ciężarowe z przyczepą   ",{"$f":"G12*H12*'wskaźniki emisji'!C38*356/1000000","v":0},null,null,"samochody ciężarowe z przyczepą   ",{"$f":"I12*J12*'wskaźniki emisji'!C38*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ciągniki ",{"$f":"G13*H13*'wskaźniki emisji'!C39*356/1000000","v":0},null,null,"ciągniki ",{"$f":"I13*J13*'wskaźniki emisji'!C39*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"autobusy ",{"$f":"G14*H14*'wskaźniki emisji'!C40*356/1000000","v":0},null,null,"autobusy ",{"$f":"I14*J14*'wskaźniki emisji'!C40*356/1000000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"razem",{"$f":"SUM(N29:N35)","v":0},null,null,"razem",{"$f":"SUM(R29:R35)","v":0}]

{"sheet":" prognoza na rok 2020 z perspek","index":12,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1],[1,2,1,16],[2,4,2,10],[2,11,2,14],[2,16,3,16],[28,2,28,16],[29,2,29,16],[30,2,30,16],[31,2,31,16],[16,0,18,0],[16,1,18,1],[16,2,16,16],[17,4,17,10],[17,11,17,14],[17,16,18,16]]}
[null,"Tabela: Finalne zużycie energii w roku 2020 w gminie [GJ] "]
["lp.","Kategoria","końcowe zużycie energii [GJ]"]
[null,null,null,null,null,null,null,null,null,null,null,"OZE",null,null,null,null,"Razem"]
[null,null,"energia elektryczna","ciepło / chłód","gaz ziemny","olej opałowy","koks opałowy","drewno","węgiel kamienny","węgiel brunatny","inne paliwa kopalne","olej roślinny","inna biomasa (t)","słoneczna","geotermiczna","LPG"]
["I","Gminne jednostki organizacyjne"]
[1,"Ogrzewanie budynków administracji publicznej",0,0,{"$f":"wyniki!F11*0.6","v":613.77085439999996},0,0,0,0,0,null,null,null,null,null,0,{"$f":"E6","v":613.77085439999996}]
[2,"Budynki administracji publicznej - energia elektryczna",{"$f":"wyniki!C12*0.7","v":950.36759999965022},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"SUM(P7,J7,H7,G7,F7,E7,C7)","v":950.36759999965022}]
[3,"Komunalne oświetlenie publiczne",{"$f":"wyniki!C13*0.8","v":290.93183999989299},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"SUM(P8,J8,H8,G8,F8,E8,C8)","v":290.93183999989299}]
[null,"Gospodarstwa domowe",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K8)","v":0},{"$f":"SUM(L6:L8)","v":0},{"$f":"SUM(M6:M8)","v":0},{"$f":"SUM(N6:N8)","v":0},{"$f":"SUM(O6:O8)","v":0},null,0]
[4,"  ogrzewanie",{"$f":"wyniki!C15*0.8","v":0},0,{"$f":"wyniki!F15*1.4","v":19205.897001983998},0,0,{"$f":"wyniki!I15*0.95","v":4153.7533999999996},{"$f":"wyniki!K15*0.4","v":9216},0,0,0,0,9298,0,0,{"$f":"SUM(C10:P10)","v":41873.650401983999}]
[5," energia elektyczna konwencjonalna",{"$f":"wyniki!C16*1.17-C12","v":1187.524839996935},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"C11+N11","v":1187.524839996935}]
[6," energia elektyczna OZE",7142,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C12","v":7142},{"$f":"C12+N10+H10","v":20593.753400000001}]
[null,"Łącznie końcowe zużycie energii",{"$f":"SUM(C6:C12)","v":9570.8242799964792},null,{"$f":"E6+E10","v":19819.667856384},{"$f":"SUM(F10:F11)","v":0},{"$f":"SUM(G10:G11)","v":0},{"$f":"SUM(H10:H11)","v":4153.7533999999996},{"$f":"I10","v":9216},{"$f":"SUM(J10:J11)","v":0},0,0,0,{"$f":"N10","v":9298},0,{"$f":"SUM(P10:P11)","v":0},{"$f":"Q6+Q7+Q8+Q10+Q11+Q12","v":52058.245536380477}]
[]
[]
[null,"Tabela: Wyniki inwentaryzacji bazowej emisji dwutlenku węgla w gminie [Mg CO2]"]
["lp.","Kategoria","emisje CO2 [t]"]
[null,null,null,null,null,null,null,null,null,null,null,"OZE",null,null,null,null,"Razem"]
[null,null,"energia elektryczna","ciepło / chłód","gaz ziemny","olej opałowy","koks opałowy","drewno","węgiel kamienny","węgiel brunatny","inne paliwa kopalne","olej roślinny","inna biomasa","słoneczna, cieplna","geotermiczna","LPG"]
["I","Gminne jednostki organizacyjne"]
[1,"Ogrzewanie budynków administracji publicznej",0,0,{"$f":"E6*'wskaźniki emisji'!C8","v":33.757396991999997},0,0,0,0,0,null,null,0,null,null,0,{"$f":"SUM(P21,J21,H21,G21,F21,E21,C21)","v":33.757396991999997}]
[2,"Budynki administracji publicznej - energia elektryczna",{"$f":"(C7/'wskaźniki emisji'!C15)*'wskaźniki emisji'!C11","v":234.95198999991354},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"SUM(P22,J22,H22,G22,F22,E22,C22)","v":234.95198999991354}]
[3,"Komunalne oświetlenie publiczne",{"$f":"(C8/'wskaźniki emisji'!C15)*'wskaźniki emisji'!C11","v":71.924815999973546},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"SUM(P23,J23,H23,G23,F23,E23,C23)","v":71.924815999973546}]
["II","Gospodarstwa domowe",null,null,null,null,null,null,null,null,{"$f":"SUM(K21:K23)","v":0},{"$f":"SUM(L21:L23)","v":0},{"$f":"SUM(M21:M23)","v":0},{"$f":"SUM(N21:N23)","v":0},{"$f":"SUM(O21:O23)","v":0}]
[1,"Gospodarstwa domowe -  ogrzewanie",{"$f":"(C10/'wskaźniki emisji'!C15)*'wskaźniki emisji'!C11","v":0},0,{"$f":"E10*'wskaźniki emisji'!C8","v":1056.3243351091198},{"$f":"F10*'wskaźniki emisji'!C9","v":0},0,{"$f":"H10*'wskaźniki emisji'!C7","v":452.75912059999996},{"$f":"I10*'wskaźniki emisji'!C10","v":903.16800000000001},0,null,null,null,null,null,0,{"$f":"SUM(C24:J25)","v":2412.2514557091199}]
[2,"Gospodarstwa domowe - energia elektyczna",{"$f":"(C11/'wskaźniki emisji'!C15)*'wskaźniki emisji'!C11","v":293.58252988813115},0,0,0,0,0,0,0,null,null,null,null,null,0,{"$f":"SUM(P26,J26,H26,G26,F26,E26,C26)","v":293.58252988813115}]
[null,"Razem",{"$f":"C21+C22+C23+C25+C26","v":600.45933588801824},0,{"$f":"E21+E22+E23+E25+E26","v":1090.0817321011198},{"$f":"SUM(F21:F26)","v":0},0,{"$f":"H25+H26+H21+H22+H23","v":452.75912059999996},{"$f":"I21+I22+I23+I25+I26","v":903.16800000000001},0,0,0,0,0,0,{"$f":"SUM(P25:P31)","v":0},{"$f":"SUM(Q21:Q26)","v":3046.4681885891378}]
[]
[null,"Transport"]
[null,"Transport lokalny",{"$f":"wyniki!C34*0.74","v":1187.5890000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q27+C32","v":4345.5500685491379}]
[null,"Tranzyt",{"$f":"wyniki!C35*0.74","v":111.49287996}]
[null,null,{"$f":"C30+C31","v":1299.0818799600002}]